2017-08-08 - 52772 - Break Fix - WMS501 - VAS Exception Report enhancement #CrystalReportsSupport
BREAK FIX
52772 - 10707 - WMS501 - VAS Exception Report - enhancement
Problem Summary
Need to exclude two VAS codes
in WMS501 report.
Admin Info
Purpose
|
Need to exclude two VAS codes in WMS501 report.
|
Requested by
|
Saravanan Lakshmanan
|
Issue Date
|
08-08-2017
|
Resolved by
|
Dhananjay G
|
Resolved Date
|
08-18-2017
|
Document Status
|
Complete
|
Detailed Problem Description
Email from Saravanan Lakshmanan on 08/08/2017:
Please move forward with having those two VAS codes excluded from the WMS 501 report :
1. If the value of label type - LAT (AVERY labels) and
2. If the value of the special service type - S12 - (Spencers Pack Slip).
Solution Analysis and Recommendations
1. Need to include VAS Codes in the report.
2. Need to validate the report with SAP infoset.
3. Need to place the report in BI development and inform NEC for promotion after successful validation.
Test Plan
Test ID
|
Test Scenario
|
Expected Results
|
1
|
Report Format.
|
Should be as per NEC crystal standard checklist.
|
2
|
Execute Crystal Report in Crystal Designer tool after changes.
|
Report should execute successfully in Crystal Designer tool.
|
3
|
Schedule the Report in NEC BI Launch Pad.
|
Report should execute successfully in NEC BI Launch Pad.
|
Resolution
1. Added the value of label type - LAT (AVERY labels) in
the below condition to the report in record selection formula section:
not ({ZSDVAS.J_3AVATL-J_3ATLTYP} in ["L01", "L02", "L03", "L04", "L05", "L06", "L07", "L08","L45", "L46", "L47", "L48", "L49", "L50", "L51", "L52", "L53", "L54", "L55", "L56", "L57", "L58", "L59", "L60", "L61", "L62", "L68", "LU2", "LU3", "LZL", "LZM", "LZN", "LZO", "LZP", "LZQ", "LZR", "LZS", "LZT", "LZU", "LZV", "LAT"]) and
2. Added the value of special service type - S12 - (Spencers Pack Slip) in
the below condition to the report in record selection formula section:
not ({ZSDVAS.J_3AVASSO-J_3ASSTYP} in ["S00", "S39", "S40","S12"]) and
3. The report is validated against SAP infoset.
4. The report was placed in BI development and NEC was informed for promotion after successful validation.
Release Information
2017-08-18 - 52772 - Rel Notes - WMS501 - VAS Exception Report enhancement - Release 001